Dataset statistics
| Number of variables | 35 |
|---|---|
| Number of observations | 5000 |
| Missing cells | 10130 |
| Missing cells (%) | 5.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.0 MiB |
| Average record size in memory | 636.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 11 |
| Text | 3 |
| DateTime | 3 |
| Boolean | 4 |
| Unsupported | 1 |
aborteddataerrorcount has constant value "" | Constant |
accommodationunavailableerrorcount has constant value "" | Constant |
failureindurationserrorcount has constant value "" | Constant |
createtripformsubmission_fastjourney has constant value "" | Constant |
overnightreductionerrorcount has constant value "" | Constant |
createtripformsubmission_childcount is highly imbalanced (57.7%) | Imbalance |
createtripformsubmission_closestcity is highly imbalanced (54.3%) | Imbalance |
createtripformsubmission_directjourney is highly imbalanced (99.7%) | Imbalance |
createtripformsubmission_extrainfo is highly imbalanced (99.3%) | Imbalance |
nogoodscoreerrorcount is highly imbalanced (94.9%) | Imbalance |
success is highly imbalanced (82.6%) | Imbalance |
timeouterrorcount is highly imbalanced (70.8%) | Imbalance |
transportunavailableerrorcount is highly imbalanced (99.7%) | Imbalance |
creationdate has 130 (2.6%) missing values | Missing |
failtimeseconds has 4870 (97.4%) missing values | Missing |
jotform_onewaytrip has 5000 (100.0%) missing values | Missing |
tripbuildtimeseconds has 130 (2.6%) missing values | Missing |
firstchoiceaccommodationunavailablecount is highly skewed (γ1 = 22.72164325) | Skewed |
noavailabledotwaccommodationerrorcount is highly skewed (γ1 = 22.06647453) | Skewed |
nofamilymanualfallbackserrorcount is highly skewed (γ1 = 37.4528303) | Skewed |
substituteaccommodationunavailablecount is highly skewed (γ1 = 22.77448326) | Skewed |
tripbuildtimeseconds is highly skewed (γ1 = 23.38040554) | Skewed |
createtripid_region has unique values | Unique |
jotform_onewaytrip is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
badproportionerrorcount has 4547 (90.9%) zeros | Zeros |
firstchoiceaccommodationunavailablecount has 1760 (35.2%) zeros | Zeros |
noavailabledotwaccommodationerrorcount has 4861 (97.2%) zeros | Zeros |
nofamilymanualfallbackserrorcount has 4995 (99.9%) zeros | Zeros |
norouteserrorcount has 3135 (62.7%) zeros | Zeros |
substituteaccommodationunavailablecount has 4773 (95.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-04 09:21:40.122273 |
|---|---|
| Analysis finished | 2024-02-04 09:21:57.533064 |
| Duration | 17.41 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
createtripid
Real number (ℝ)
| Distinct | 2801 |
|---|---|
| Distinct (%) | 56.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6009212 × 1014 |
| Minimum | 6.0001285 × 1014 |
|---|---|
| Maximum | 9.2228048 × 1014 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 6.0001285 × 1014 |
|---|---|
| 5-th percentile | 6.1609005 × 1014 |
| Q1 | 6.7918541 × 1014 |
| median | 7.5937461 × 1014 |
| Q3 | 8.387415 × 1014 |
| 95-th percentile | 9.0617686 × 1014 |
| Maximum | 9.2228048 × 1014 |
| Range | 3.2226763 × 1014 |
| Interquartile range (IQR) | 1.5955609 × 1014 |
Descriptive statistics
| Standard deviation | 9.3126107 × 1013 |
|---|---|
| Coefficient of variation (CV) | 0.1225195 |
| Kurtosis | -1.193467 |
| Mean | 7.6009212 × 1014 |
| Median Absolute Deviation (MAD) | 7.9707081 × 1013 |
| Skewness | 0.024331046 |
| Sum | 3.8004606 × 1018 |
| Variance | 8.6724717 × 1027 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8.780682326 × 1014 | 11 | 0.2% |
| 6.144077872 × 1014 | 10 | 0.2% |
| 8.733860145 × 1014 | 9 | 0.2% |
| 6.859121871 × 1014 | 9 | 0.2% |
| 6.325074452 × 1014 | 8 | 0.2% |
| 8.917458881 × 1014 | 8 | 0.2% |
| 7.945427677 × 1014 | 8 | 0.2% |
| 9.222804796 × 1014 | 8 | 0.2% |
| 8.603450218 × 1014 | 7 | 0.1% |
| 7.119398435 × 1014 | 7 | 0.1% |
| Other values (2791) | 4915 |
| Value | Count | Frequency (%) |
| 6.000128507 × 1014 | 1 | |
| 6.001193436 × 1014 | 1 | |
| 6.005894494 × 1014 | 1 | |
| 6.007711331 × 1014 | 1 | |
| 6.009363974 × 1014 | 2 | |
| 6.010832743 × 1014 | 2 | |
| 6.010949153 × 1014 | 1 | |
| 6.01173187 × 1014 | 1 | |
| 6.014506832 × 1014 | 1 | |
| 6.01476539 × 1014 | 1 |
| Value | Count | Frequency (%) |
| 9.222804796 × 1014 | 8 | |
| 9.221832521 × 1014 | 2 | < 0.1% |
| 9.220981713 × 1014 | 2 | < 0.1% |
| 9.220771286 × 1014 | 5 | |
| 9.217798978 × 1014 | 1 | < 0.1% |
| 9.217496784 × 1014 | 1 | < 0.1% |
| 9.214071218 × 1014 | 3 | 0.1% |
| 9.212305815 × 1014 | 1 | < 0.1% |
| 9.21134385 × 1014 | 1 | < 0.1% |
| 9.210759547 × 1014 | 3 | 0.1% |
region
Categorical
| Distinct | 26 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 344.5 KiB |
| Highlands & Islands | |
|---|---|
| Italian Riviera | |
| Northern Italy | |
| Alsace | |
| North & Central Spain | |
| Other values (21) |
Length
| Max length | 21 |
|---|---|
| Median length | 15 |
| Mean length | 13.533 |
| Min length | 5 |
Characters and Unicode
| Total characters | 67665 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Southern Italy |
|---|---|
| 2nd row | Italian Riviera |
| 3rd row | Highlands & Islands |
| 4th row | East Highlands |
| 5th row | Yorkshire |
Common Values
| Value | Count | Frequency (%) |
| Highlands & Islands | 838 | |
| Italian Riviera | 538 | |
| Northern Italy | 534 | |
| Alsace | 505 | |
| North & Central Spain | 416 | |
| East Highlands | 360 | 7.2% |
| Southern Italy | 317 | 6.3% |
| Switzerland | 224 | 4.5% |
| Andalusia | 186 | 3.7% |
| French Riviera | 162 | 3.2% |
| Other values (16) | 920 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1254 | ||
| highlands | 1198 | |
| italy | 851 | 8.5% |
| islands | 838 | 8.4% |
| riviera | 700 | 7.0% |
| italian | 538 | 5.4% |
| northern | 534 | 5.4% |
| alsace | 505 | 5.1% |
| north | 440 | 4.4% |
| spain | 417 | 4.2% |
| Other values (24) | 2698 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7688 | 11.4% |
| l | 5383 | 8.0% |
| n | 5337 | 7.9% |
| 4973 | 7.3% | |
| i | 4485 | 6.6% |
| s | 4464 | 6.6% |
| t | 4195 | 6.2% |
| r | 4071 | 6.0% |
| e | 3599 | 5.3% |
| h | 2940 | 4.3% |
| Other values (29) | 20530 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 52524 | |
| Uppercase Letter | 8784 | 13.0% |
| Space Separator | 4973 | 7.3% |
| Other Punctuation | 1254 | 1.9% |
| Dash Punctuation | 130 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7688 | |
| l | 5383 | |
| n | 5337 | |
| i | 4485 | |
| s | 4464 | |
| t | 4195 | |
| r | 4071 | |
| e | 3599 | |
| h | 2940 | 5.6% |
| d | 2624 | 5.0% |
| Other values (12) | 7738 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 2227 | |
| H | 1263 | |
| N | 1088 | |
| S | 1058 | |
| C | 756 | 8.6% |
| R | 701 | 8.0% |
| A | 691 | 7.9% |
| E | 360 | 4.1% |
| F | 227 | 2.6% |
| Y | 145 | 1.7% |
| Other values (4) | 268 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 4973 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1254 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 130 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61308 | |
| Common | 6357 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7688 | |
| l | 5383 | 8.8% |
| n | 5337 | 8.7% |
| i | 4485 | 7.3% |
| s | 4464 | 7.3% |
| t | 4195 | 6.8% |
| r | 4071 | 6.6% |
| e | 3599 | 5.9% |
| h | 2940 | 4.8% |
| d | 2624 | 4.3% |
| Other values (26) | 16522 |
Common
| Value | Count | Frequency (%) |
| 4973 | ||
| & | 1254 | 19.7% |
| - | 130 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67665 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 7688 | 11.4% |
| l | 5383 | 8.0% |
| n | 5337 | 7.9% |
| 4973 | 7.3% | |
| i | 4485 | 6.6% |
| s | 4464 | 6.6% |
| t | 4195 | 6.2% |
| r | 4071 | 6.0% |
| e | 3599 | 5.3% |
| h | 2940 | 4.3% |
| Other values (29) | 20530 |
UNIQUE
| Distinct | 5000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 422.6 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 31 |
| Mean length | 29.533 |
| Min length | 21 |
Characters and Unicode
| Total characters | 147665 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 891585467457763_Southern Italy |
|---|---|
| 2nd row | 891585467457763_Italian Riviera |
| 3rd row | 856446659120383_Highlands & Islands |
| 4th row | 856446659120383_East Highlands |
| 5th row | 643110738642468_Yorkshire |
| Value | Count | Frequency (%) |
| 1254 | 12.6% | |
| italy | 851 | 8.5% |
| islands | 838 | 8.4% |
| riviera | 700 | 7.0% |
| spain | 416 | 4.2% |
| central | 416 | 4.2% |
| highlands | 360 | 3.6% |
| country | 83 | 0.8% |
| downs | 30 | 0.3% |
| wales | 24 | 0.2% |
| Other values (5001) | 5001 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 8647 | 5.9% |
| 6 | 8547 | 5.8% |
| 8 | 8546 | 5.8% |
| a | 7688 | 5.2% |
| 2 | 7267 | 4.9% |
| 4 | 7129 | 4.8% |
| 9 | 7114 | 4.8% |
| 0 | 7030 | 4.8% |
| 5 | 7025 | 4.8% |
| 1 | 6994 | 4.7% |
| Other values (40) | 71678 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 75000 | |
| Lowercase Letter | 52524 | |
| Uppercase Letter | 8784 | 5.9% |
| Connector Punctuation | 5000 | 3.4% |
| Space Separator | 4973 | 3.4% |
| Other Punctuation | 1254 | 0.8% |
| Dash Punctuation | 130 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 7688 | |
| l | 5383 | |
| n | 5337 | |
| i | 4485 | |
| s | 4464 | |
| t | 4195 | |
| r | 4071 | |
| e | 3599 | |
| h | 2940 | 5.6% |
| d | 2624 | 5.0% |
| Other values (12) | 7738 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 2227 | |
| H | 1263 | |
| N | 1088 | |
| S | 1058 | |
| C | 756 | 8.6% |
| R | 701 | 8.0% |
| A | 691 | 7.9% |
| E | 360 | 4.1% |
| F | 227 | 2.6% |
| Y | 145 | 1.7% |
| Other values (4) | 268 | 3.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 8647 | |
| 6 | 8547 | |
| 8 | 8546 | |
| 2 | 7267 | |
| 4 | 7129 | |
| 9 | 7114 | |
| 0 | 7030 | |
| 5 | 7025 | |
| 1 | 6994 | |
| 3 | 6701 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 5000 |
Space Separator
| Value | Count | Frequency (%) |
| 4973 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1254 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 130 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86357 | |
| Latin | 61308 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 7688 | |
| l | 5383 | 8.8% |
| n | 5337 | 8.7% |
| i | 4485 | 7.3% |
| s | 4464 | 7.3% |
| t | 4195 | 6.8% |
| r | 4071 | 6.6% |
| e | 3599 | 5.9% |
| h | 2940 | 4.8% |
| d | 2624 | 4.3% |
| Other values (26) | 16522 |
Common
| Value | Count | Frequency (%) |
| 7 | 8647 | |
| 6 | 8547 | |
| 8 | 8546 | |
| 2 | 7267 | |
| 4 | 7129 | |
| 9 | 7114 | |
| 0 | 7030 | |
| 5 | 7025 | |
| 1 | 6994 | |
| 3 | 6701 | |
| Other values (4) | 11357 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 147665 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | 8647 | 5.9% |
| 6 | 8547 | 5.8% |
| 8 | 8546 | 5.8% |
| a | 7688 | 5.2% |
| 2 | 7267 | 4.9% |
| 4 | 7129 | 4.8% |
| 9 | 7114 | 4.8% |
| 0 | 7030 | 4.8% |
| 5 | 7025 | 4.8% |
| 1 | 6994 | 4.7% |
| Other values (40) | 71678 |
requestdate
Date
| Distinct | 2801 |
|---|---|
| Distinct (%) | 56.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2024-01-20 10:44:58.368000 |
|---|---|
| Maximum | 2024-01-25 00:44:32.072000 |
Histogram with fixed size bins (bins=50)
aborteddataerrorcount
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
accommodationunavailableerrorcount
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
createtripformsubmission_adultcount
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1076 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.77778096 |
|---|---|
| Coefficient of variation (CV) | 0.36903633 |
| Kurtosis | 6.5728088 |
| Mean | 2.1076 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0439263 |
| Sum | 10538 |
| Variance | 0.60494323 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 2 | 3741 | |
| 1 | 609 | 12.2% |
| 4 | 303 | 6.1% |
| 3 | 273 | 5.5% |
| 6 | 46 | 0.9% |
| 5 | 28 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 609 | 12.2% |
| 2 | 3741 | |
| 3 | 273 | 5.5% |
| 4 | 303 | 6.1% |
| 5 | 28 | 0.6% |
| 6 | 46 | 0.9% |
| Value | Count | Frequency (%) |
| 6 | 46 | 0.9% |
| 5 | 28 | 0.6% |
| 4 | 303 | 6.1% |
| 3 | 273 | 5.5% |
| 2 | 3741 | |
| 1 | 609 | 12.2% |
badproportionerrorcount
Real number (ℝ)
ZEROS
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4 |
| Minimum | 0 |
|---|---|
| Maximum | 88 |
| Zeros | 4547 |
| Zeros (%) | 90.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 88 |
| Range | 88 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.3992221 |
|---|---|
| Coefficient of variation (CV) | 8.4980553 |
| Kurtosis | 361.87438 |
| Mean | 0.4 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.276506 |
| Sum | 2000 |
| Variance | 11.554711 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=32)
| Value | Count | Frequency (%) |
| 0 | 4547 | |
| 1 | 226 | 4.5% |
| 2 | 86 | 1.7% |
| 3 | 59 | 1.2% |
| 4 | 23 | 0.5% |
| 5 | 11 | 0.2% |
| 6 | 6 | 0.1% |
| 14 | 4 | 0.1% |
| 40 | 3 | 0.1% |
| 26 | 2 | < 0.1% |
| Other values (22) | 33 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 4547 | |
| 1 | 226 | 4.5% |
| 2 | 86 | 1.7% |
| 3 | 59 | 1.2% |
| 4 | 23 | 0.5% |
| 5 | 11 | 0.2% |
| 6 | 6 | 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 88 | 1 | < 0.1% |
| 86 | 2 | |
| 80 | 1 | < 0.1% |
| 48 | 2 | |
| 44 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42 | 1 | < 0.1% |
| 40 | 3 | |
| 37 | 2 | |
| 32 | 1 | < 0.1% |
| Distinct | 110 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 291.3 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 2 |
| Mean length | 2.6262 |
| Min length | 2 |
Characters and Unicode
| Total characters | 13131 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 18 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | {} |
|---|---|
| 2nd row | {} |
| 3rd row | {} |
| 4th row | {} |
| 5th row | {} |
| Value | Count | Frequency (%) |
| 3997 | ||
| 15 | 100 | 2.0% |
| 13 | 88 | 1.8% |
| 14 | 70 | 1.4% |
| 12 | 49 | 1.0% |
| 9 | 40 | 0.8% |
| 7 | 40 | 0.8% |
| 11 | 38 | 0.8% |
| 6 | 37 | 0.7% |
| 8 | 34 | 0.7% |
| Other values (100) | 507 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| 1 | 1182 | 9.0% |
| , | 548 | 4.2% |
| 5 | 259 | 2.0% |
| 3 | 233 | 1.8% |
| 9 | 174 | 1.3% |
| 2 | 171 | 1.3% |
| 4 | 142 | 1.1% |
| 0 | 133 | 1.0% |
| Other values (3) | 289 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Open Punctuation | 5000 | |
| Close Punctuation | 5000 | |
| Decimal Number | 2583 | |
| Other Punctuation | 548 | 4.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1182 | |
| 5 | 259 | 10.0% |
| 3 | 233 | 9.0% |
| 9 | 174 | 6.7% |
| 2 | 171 | 6.6% |
| 4 | 142 | 5.5% |
| 0 | 133 | 5.1% |
| 7 | 120 | 4.6% |
| 8 | 96 | 3.7% |
| 6 | 73 | 2.8% |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 5000 |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 5000 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 548 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 13131 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| 1 | 1182 | 9.0% |
| , | 548 | 4.2% |
| 5 | 259 | 2.0% |
| 3 | 233 | 1.8% |
| 9 | 174 | 1.3% |
| 2 | 171 | 1.3% |
| 4 | 142 | 1.1% |
| 0 | 133 | 1.0% |
| Other values (3) | 289 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13131 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| 1 | 1182 | 9.0% |
| , | 548 | 4.2% |
| 5 | 259 | 2.0% |
| 3 | 233 | 1.8% |
| 9 | 174 | 1.3% |
| 2 | 171 | 1.3% |
| 4 | 142 | 1.1% |
| 0 | 133 | 1.0% |
| Other values (3) | 289 | 2.2% |
createtripformsubmission_childcount
Categorical
IMBALANCE
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 | 67 |
| 4 | 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4002 | |
| 1 | 526 | 10.5% |
| 2 | 401 | 8.0% |
| 3 | 67 | 1.3% |
| 4 | 4 | 0.1% |
createtripformsubmission_closestcity_id
Real number (ℝ)
| Distinct | 48 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31547490 |
| Minimum | -1 |
|---|---|
| Maximum | 8.3521155 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 55 |
| Negative (%) | 1.1% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 26 |
| Q1 | 26 |
| median | 26 |
| Q3 | 3117 |
| 95-th percentile | 1.8393659 × 108 |
| Maximum | 8.3521155 × 108 |
| Range | 8.3521155 × 108 |
| Interquartile range (IQR) | 3091 |
Descriptive statistics
| Standard deviation | 1.2766796 × 108 |
|---|---|
| Coefficient of variation (CV) | 4.0468501 |
| Kurtosis | 28.970181 |
| Mean | 31547490 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.3635578 |
| Sum | 1.5773745 × 1011 |
| Variance | 1.6299109 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 26 | 3255 | |
| 22371672 | 276 | 5.5% |
| 34 | 180 | 3.6% |
| 28 | 144 | 2.9% |
| 22370660 | 110 | 2.2% |
| 22371862 | 102 | 2.0% |
| 183936590 | 81 | 1.6% |
| 29 | 75 | 1.5% |
| 42771065 | 57 | 1.1% |
| -1 | 55 | 1.1% |
| Other values (38) | 665 | 13.3% |
| Value | Count | Frequency (%) |
| -1 | 55 | 1.1% |
| 26 | 3255 | |
| 28 | 144 | 2.9% |
| 29 | 75 | 1.5% |
| 34 | 180 | 3.6% |
| 40 | 27 | 0.5% |
| 51 | 6 | 0.1% |
| 3117 | 50 | 1.0% |
| 1635547 | 25 | 0.5% |
| 8900175 | 13 | 0.3% |
| Value | Count | Frequency (%) |
| 835211552 | 21 | |
| 834890881 | 17 | |
| 834890871 | 3 | 0.1% |
| 834890865 | 9 | 0.2% |
| 834890845 | 15 | |
| 833158856 | 24 | |
| 663365563 | 9 | 0.2% |
| 650404624 | 21 | |
| 571902488 | 3 | 0.1% |
| 394536322 | 2 | < 0.1% |
createtripformsubmission_closestcity
Categorical
IMBALANCE
| Distinct | 48 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 311.2 KiB |
| London | |
|---|---|
| Paris | 276 |
| Manchester | 180 |
| Birmingham | 144 |
| Newcastle | 110 |
| Other values (43) |
Length
| Max length | 17 |
|---|---|
| Median length | 6 |
| Mean length | 6.706 |
| Min length | 4 |
Characters and Unicode
| Total characters | 33530 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | London |
|---|---|
| 2nd row | London |
| 3rd row | Coventry |
| 4th row | Coventry |
| 5th row | Birmingham |
Common Values
| Value | Count | Frequency (%) |
| London | 3255 | |
| Paris | 276 | 5.5% |
| Manchester | 180 | 3.6% |
| Birmingham | 144 | 2.9% |
| Newcastle | 110 | 2.2% |
| Edinburgh | 102 | 2.0% |
| Cardiff | 81 | 1.6% |
| Bristol | 75 | 1.5% |
| Liverpool | 57 | 1.1% |
| Glasgow | 55 | 1.1% |
| Other values (38) | 665 | 13.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| london | 3255 | |
| paris | 276 | 5.4% |
| manchester | 180 | 3.6% |
| birmingham | 144 | 2.8% |
| newcastle | 110 | 2.2% |
| edinburgh | 102 | 2.0% |
| cardiff | 81 | 1.6% |
| bristol | 75 | 1.5% |
| liverpool | 57 | 1.1% |
| glasgow | 55 | 1.1% |
| Other values (41) | 732 | 14.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 7200 | |
| o | 7168 | |
| d | 3712 | |
| L | 3403 | |
| e | 1263 | 3.8% |
| r | 1263 | 3.8% |
| i | 1172 | 3.5% |
| a | 1097 | 3.3% |
| s | 889 | 2.7% |
| t | 806 | 2.4% |
| Other values (33) | 5557 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 28339 | |
| Uppercase Letter | 5067 | 15.1% |
| Space Separator | 98 | 0.3% |
| Other Punctuation | 26 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 7200 | |
| o | 7168 | |
| d | 3712 | |
| e | 1263 | 4.5% |
| r | 1263 | 4.5% |
| i | 1172 | 4.1% |
| a | 1097 | 3.9% |
| s | 889 | 3.1% |
| t | 806 | 2.8% |
| h | 789 | 2.8% |
| Other values (13) | 2980 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 3403 | |
| B | 325 | 6.4% |
| P | 294 | 5.8% |
| M | 195 | 3.8% |
| N | 192 | 3.8% |
| C | 174 | 3.4% |
| E | 128 | 2.5% |
| S | 101 | 2.0% |
| G | 64 | 1.3% |
| A | 42 | 0.8% |
| Other values (8) | 149 | 2.9% |
Space Separator
| Value | Count | Frequency (%) |
| 98 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 26 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 33406 | |
| Common | 124 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 7200 | |
| o | 7168 | |
| d | 3712 | |
| L | 3403 | |
| e | 1263 | 3.8% |
| r | 1263 | 3.8% |
| i | 1172 | 3.5% |
| a | 1097 | 3.3% |
| s | 889 | 2.7% |
| t | 806 | 2.4% |
| Other values (31) | 5433 |
Common
| Value | Count | Frequency (%) |
| 98 | ||
| ' | 26 | 21.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33530 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 7200 | |
| o | 7168 | |
| d | 3712 | |
| L | 3403 | |
| e | 1263 | 3.8% |
| r | 1263 | 3.8% |
| i | 1172 | 3.5% |
| a | 1097 | 3.3% |
| s | 889 | 2.7% |
| t | 806 | 2.4% |
| Other values (33) | 5557 |
creationdate
Date
MISSING
| Distinct | 4868 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 130 |
| Missing (%) | 2.6% |
| Memory size | 39.2 KiB |
| Minimum | 2024-01-20 10:45:09.267000 |
|---|---|
| Maximum | 2024-01-25 00:44:35.807000 |
Histogram with fixed size bins (bins=50)
createtripformsubmission_directjourney
Boolean
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.0 KiB |
| False | |
|---|---|
| True | 1 |
| Value | Count | Frequency (%) |
| False | 4999 | |
| True | 1 | < 0.1% |
createtripformsubmission_durationdays
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.8828 |
| Minimum | 3 |
|---|---|
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 7 |
| median | 7 |
| Q3 | 12 |
| 95-th percentile | 18 |
| Maximum | 25 |
| Range | 22 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 4.3493962 |
|---|---|
| Coefficient of variation (CV) | 0.48964248 |
| Kurtosis | 0.66252205 |
| Mean | 8.8828 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.9474632 |
| Sum | 44414 |
| Variance | 18.917248 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 7 | 1574 | |
| 10 | 641 | |
| 14 | 608 | 12.2% |
| 3 | 514 | 10.3% |
| 5 | 334 | 6.7% |
| 12 | 224 | 4.5% |
| 21 | 201 | 4.0% |
| 4 | 195 | 3.9% |
| 8 | 170 | 3.4% |
| 9 | 162 | 3.2% |
| Other values (10) | 377 | 7.5% |
| Value | Count | Frequency (%) |
| 3 | 514 | 10.3% |
| 4 | 195 | 3.9% |
| 5 | 334 | 6.7% |
| 6 | 92 | 1.8% |
| 7 | 1574 | |
| 8 | 170 | 3.4% |
| 9 | 162 | 3.2% |
| 10 | 641 | |
| 11 | 64 | 1.3% |
| 12 | 224 | 4.5% |
| Value | Count | Frequency (%) |
| 25 | 1 | < 0.1% |
| 21 | 201 | 4.0% |
| 20 | 25 | 0.5% |
| 19 | 9 | 0.2% |
| 18 | 23 | 0.5% |
| 17 | 15 | 0.3% |
| 16 | 30 | 0.6% |
| 15 | 60 | 1.2% |
| 14 | 608 | |
| 13 | 58 | 1.2% |
array_to_string
Text
| Distinct | 698 |
|---|---|
| Distinct (%) | 14.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 452.2 KiB |
Length
| Max length | 91 |
|---|---|
| Median length | 60 |
| Mean length | 35.5758 |
| Min length | 3 |
Characters and Unicode
| Total characters | 177879 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 177 ? |
|---|---|
| Unique (%) | 3.5% |
Sample
| 1st row | Arts and Culture,History,Adventure |
|---|---|
| 2nd row | Arts and Culture,History,Adventure |
| 3rd row | Relaxation,History |
| 4th row | Relaxation,History |
| 5th row | History,Nature,Food and Drink |
| Value | Count | Frequency (%) |
| and | 4909 | |
| drink | 845 | 5.1% |
| for | 816 | 5.0% |
| arts | 655 | 4.0% |
| food | 580 | 3.5% |
| drink,nature | 485 | 2.9% |
| relaxation,food | 483 | 2.9% |
| good | 419 | 2.5% |
| culture,history,food | 401 | 2.4% |
| relaxation,arts | 395 | 2.4% |
| Other values (370) | 6462 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 14766 | 8.3% |
| r | 14738 | 8.3% |
| t | 14171 | 8.0% |
| a | 13670 | 7.7% |
| n | 12204 | 6.9% |
| , | 11462 | 6.4% |
| 11450 | 6.4% | |
| i | 11073 | 6.2% |
| d | 10761 | 6.0% |
| e | 10281 | 5.8% |
| Other values (18) | 53303 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 133710 | |
| Uppercase Letter | 21257 | 12.0% |
| Other Punctuation | 11462 | 6.4% |
| Space Separator | 11450 | 6.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 14766 | |
| r | 14738 | |
| t | 14171 | |
| a | 13670 | |
| n | 12204 | |
| i | 11073 | |
| d | 10761 | |
| e | 10281 | |
| u | 7586 | |
| s | 5791 | 4.3% |
| Other values (8) | 18669 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 3490 | |
| H | 3201 | |
| D | 3135 | |
| F | 3135 | |
| A | 2859 | |
| R | 2847 | |
| C | 1774 | |
| G | 816 | 3.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 11462 |
Space Separator
| Value | Count | Frequency (%) |
| 11450 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 154967 | |
| Common | 22912 | 12.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 14766 | 9.5% |
| r | 14738 | 9.5% |
| t | 14171 | 9.1% |
| a | 13670 | 8.8% |
| n | 12204 | 7.9% |
| i | 11073 | 7.1% |
| d | 10761 | 6.9% |
| e | 10281 | 6.6% |
| u | 7586 | 4.9% |
| s | 5791 | 3.7% |
| Other values (16) | 39926 |
Common
| Value | Count | Frequency (%) |
| , | 11462 | |
| 11450 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 177879 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 14766 | 8.3% |
| r | 14738 | 8.3% |
| t | 14171 | 8.0% |
| a | 13670 | 7.7% |
| n | 12204 | 6.9% |
| , | 11462 | 6.4% |
| 11450 | 6.4% | |
| i | 11073 | 6.2% |
| d | 10761 | 6.0% |
| e | 10281 | 5.8% |
| Other values (18) | 53303 |
createtripformsubmission_extrainfo
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 288.3 KiB |
| {} | |
|---|---|
| {Good for vegans"}" | 3 |
Length
| Max length | 19 |
|---|---|
| Median length | 2 |
| Mean length | 2.0102 |
| Min length | 2 |
Characters and Unicode
| Total characters | 10051 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | {} |
|---|---|
| 2nd row | {} |
| 3rd row | {} |
| 4th row | {} |
| 5th row | {} |
Common Values
| Value | Count | Frequency (%) |
| {} | 4997 | |
| {Good for vegans"}" | 3 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4997 | ||
| good | 3 | 0.1% |
| for | 3 | 0.1% |
| vegans | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| o | 9 | 0.1% |
| 6 | 0.1% | |
| " | 6 | 0.1% |
| G | 3 | < 0.1% |
| d | 3 | < 0.1% |
| f | 3 | < 0.1% |
| r | 3 | < 0.1% |
| v | 3 | < 0.1% |
| Other values (5) | 15 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Open Punctuation | 5000 | |
| Close Punctuation | 5000 | |
| Lowercase Letter | 36 | 0.4% |
| Space Separator | 6 | 0.1% |
| Other Punctuation | 6 | 0.1% |
| Uppercase Letter | 3 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 9 | |
| d | 3 | 8.3% |
| f | 3 | 8.3% |
| r | 3 | 8.3% |
| v | 3 | 8.3% |
| e | 3 | 8.3% |
| g | 3 | 8.3% |
| a | 3 | 8.3% |
| n | 3 | 8.3% |
| s | 3 | 8.3% |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 5000 |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 5000 |
Space Separator
| Value | Count | Frequency (%) |
| 6 |
Other Punctuation
| Value | Count | Frequency (%) |
| " | 6 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10012 | |
| Latin | 39 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 9 | |
| G | 3 | 7.7% |
| d | 3 | 7.7% |
| f | 3 | 7.7% |
| r | 3 | 7.7% |
| v | 3 | 7.7% |
| e | 3 | 7.7% |
| g | 3 | 7.7% |
| a | 3 | 7.7% |
| n | 3 | 7.7% |
Common
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| 6 | 0.1% | |
| " | 6 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10051 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| { | 5000 | |
| } | 5000 | |
| o | 9 | 0.1% |
| 6 | 0.1% | |
| " | 6 | 0.1% |
| G | 3 | < 0.1% |
| d | 3 | < 0.1% |
| f | 3 | < 0.1% |
| r | 3 | < 0.1% |
| v | 3 | < 0.1% |
| Other values (5) | 15 | 0.1% |
failtimeseconds
Real number (ℝ)
MISSING
| Distinct | 127 |
|---|---|
| Distinct (%) | 97.7% |
| Missing | 4870 |
| Missing (%) | 97.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 593.91354 |
| Minimum | 2.65 |
|---|---|
| Maximum | 28218.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 2.65 |
|---|---|
| 5-th percentile | 4.2635 |
| Q1 | 7.4425 |
| median | 27.725 |
| Q3 | 61.03 |
| 95-th percentile | 824.216 |
| Maximum | 28218.37 |
| Range | 28215.72 |
| Interquartile range (IQR) | 53.5875 |
Descriptive statistics
| Standard deviation | 3195.0613 |
|---|---|
| Coefficient of variation (CV) | 5.3796741 |
| Kurtosis | 53.573633 |
| Mean | 593.91354 |
| Median Absolute Deviation (MAD) | 21.27 |
| Skewness | 7.1194547 |
| Sum | 77208.76 |
| Variance | 10208416 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31.2 | 2 | < 0.1% |
| 6.83 | 2 | < 0.1% |
| 30.78 | 2 | < 0.1% |
| 341.21 | 1 | < 0.1% |
| 5.32 | 1 | < 0.1% |
| 45.31 | 1 | < 0.1% |
| 21.65 | 1 | < 0.1% |
| 48.94 | 1 | < 0.1% |
| 2.87 | 1 | < 0.1% |
| 10.69 | 1 | < 0.1% |
| Other values (117) | 117 | 2.3% |
| (Missing) | 4870 |
| Value | Count | Frequency (%) |
| 2.65 | 1 | |
| 2.87 | 1 | |
| 2.91 | 1 | |
| 3.26 | 1 | |
| 3.56 | 1 | |
| 3.93 | 1 | |
| 4.25 | 1 | |
| 4.28 | 1 | |
| 4.6 | 1 | |
| 4.64 | 1 |
| Value | Count | Frequency (%) |
| 28218.37 | 1 | |
| 19266.32 | 1 | |
| 12860.31 | 1 | |
| 4860.36 | 1 | |
| 1260.54 | 1 | |
| 1041.07 | 1 | |
| 932.72 | 1 | |
| 691.6 | 1 | |
| 549.48 | 1 | |
| 542.18 | 1 |
failureindurationserrorcount
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
createtripformsubmission_fastjourney
Boolean
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.0 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 5000 |
firstchoiceaccommodationunavailablecount
Real number (ℝ)
SKEWED ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.404 |
| Minimum | 0 |
|---|---|
| Maximum | 396 |
| Zeros | 1760 |
| Zeros (%) | 35.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 396 |
| Range | 396 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 12.920517 |
|---|---|
| Coefficient of variation (CV) | 9.2026478 |
| Kurtosis | 555.84932 |
| Mean | 1.404 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.721643 |
| Sum | 7020 |
| Variance | 166.93977 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 1 | 3042 | |
| 0 | 1760 | |
| 2 | 106 | 2.1% |
| 3 | 24 | 0.5% |
| 5 | 12 | 0.2% |
| 4 | 10 | 0.2% |
| 6 | 6 | 0.1% |
| 18 | 4 | 0.1% |
| 25 | 3 | 0.1% |
| 9 | 3 | 0.1% |
| Other values (26) | 30 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 1760 | |
| 1 | 3042 | |
| 2 | 106 | 2.1% |
| 3 | 24 | 0.5% |
| 4 | 10 | 0.2% |
| 5 | 12 | 0.2% |
| 6 | 6 | 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 396 | 1 | |
| 338 | 2 | |
| 314 | 1 | |
| 294 | 1 | |
| 258 | 1 | |
| 226 | 1 | |
| 208 | 1 | |
| 182 | 1 | |
| 170 | 1 | |
| 122 | 1 |
noavailabledotwaccommodationerrorcount
Real number (ℝ)
SKEWED ZEROS
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9886 |
| Minimum | 0 |
|---|---|
| Maximum | 1118 |
| Zeros | 4861 |
| Zeros (%) | 97.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1118 |
| Range | 1118 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 37.3858 |
|---|---|
| Coefficient of variation (CV) | 18.80006 |
| Kurtosis | 514.53629 |
| Mean | 1.9886 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.066475 |
| Sum | 9943 |
| Variance | 1397.698 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 0 | 4861 | |
| 1 | 65 | 1.3% |
| 2 | 24 | 0.5% |
| 4 | 8 | 0.2% |
| 5 | 7 | 0.1% |
| 6 | 5 | 0.1% |
| 3 | 5 | 0.1% |
| 55 | 2 | < 0.1% |
| 48 | 2 | < 0.1% |
| 348 | 1 | < 0.1% |
| Other values (20) | 20 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4861 | |
| 1 | 65 | 1.3% |
| 2 | 24 | 0.5% |
| 3 | 5 | 0.1% |
| 4 | 8 | 0.2% |
| 5 | 7 | 0.1% |
| 6 | 5 | 0.1% |
| 9 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1118 | 1 | |
| 920 | 1 | |
| 919 | 1 | |
| 846 | 1 | |
| 811 | 1 | |
| 792 | 1 | |
| 706 | 1 | |
| 681 | 1 | |
| 622 | 1 | |
| 581 | 1 |
nofamilymanualfallbackserrorcount
Real number (ℝ)
SKEWED ZEROS
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0392 |
| Minimum | 0 |
|---|---|
| Maximum | 62 |
| Zeros | 4995 |
| Zeros (%) | 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 62 |
| Range | 62 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3477487 |
|---|---|
| Coefficient of variation (CV) | 34.381345 |
| Kurtosis | 1477.9198 |
| Mean | 0.0392 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 37.45283 |
| Sum | 196 |
| Variance | 1.8164266 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 4995 | |
| 62 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 4995 | |
| 12 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 62 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 62 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 0 | 4995 |
nogoodscoreerrorcount
Categorical
IMBALANCE
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 | |
|---|---|
| 1 | 38 |
| 2 | 18 |
| 4 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4943 | |
| 1 | 38 | 0.8% |
| 2 | 18 | 0.4% |
| 4 | 1 | < 0.1% |
norouteserrorcount
Real number (ℝ)
ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1204 |
| Minimum | 0 |
|---|---|
| Maximum | 134 |
| Zeros | 3135 |
| Zeros (%) | 62.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 134 |
| Range | 134 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 4.2943209 |
|---|---|
| Coefficient of variation (CV) | 3.8328462 |
| Kurtosis | 428.16635 |
| Mean | 1.1204 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.574793 |
| Sum | 5602 |
| Variance | 18.441192 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 0 | 3135 | |
| 1 | 899 | 18.0% |
| 2 | 428 | 8.6% |
| 3 | 200 | 4.0% |
| 4 | 90 | 1.8% |
| 5 | 51 | 1.0% |
| 9 | 44 | 0.9% |
| 6 | 34 | 0.7% |
| 10 | 23 | 0.5% |
| 7 | 21 | 0.4% |
| Other values (26) | 75 | 1.5% |
| Value | Count | Frequency (%) |
| 0 | 3135 | |
| 1 | 899 | 18.0% |
| 2 | 428 | 8.6% |
| 3 | 200 | 4.0% |
| 4 | 90 | 1.8% |
| 5 | 51 | 1.0% |
| 6 | 34 | 0.7% |
| 7 | 21 | 0.4% |
| 8 | 21 | 0.4% |
| 9 | 44 | 0.9% |
| Value | Count | Frequency (%) |
| 134 | 1 | |
| 120 | 1 | |
| 100 | 1 | |
| 93 | 1 | |
| 65 | 1 | |
| 60 | 1 | |
| 50 | 1 | |
| 49 | 1 | |
| 42 | 1 | |
| 40 | 1 |
jotform_onewaytrip
Unsupported
MISSING REJECTED UNSUPPORTED
| Missing | 5000 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 39.2 KiB |
overnightreductionerrorcount
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5000 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5000 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5000 |
| Distinct | 403 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 39.2 KiB |
| Minimum | 2024-01-30 00:00:00 |
|---|---|
| Maximum | 2032-03-20 00:00:00 |
Histogram with fixed size bins (bins=50)
createtripformsubmission_roomcount
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.174 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.45493449 |
|---|---|
| Coefficient of variation (CV) | 0.38750809 |
| Kurtosis | 16.492839 |
| Mean | 1.174 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.3105235 |
| Sum | 5870 |
| Variance | 0.20696539 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 4255 | |
| 2 | 639 | 12.8% |
| 3 | 97 | 1.9% |
| 6 | 4 | 0.1% |
| 4 | 3 | 0.1% |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 4255 | |
| 2 | 639 | 12.8% |
| 3 | 97 | 1.9% |
| 4 | 3 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 4 | 0.1% |
| Value | Count | Frequency (%) |
| 6 | 4 | 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 3 | 0.1% |
| 3 | 97 | 1.9% |
| 2 | 639 | 12.8% |
| 1 | 4255 |
substituteaccommodationunavailablecount
Real number (ℝ)
SKEWED ZEROS
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7678 |
| Minimum | 0 |
|---|---|
| Maximum | 396 |
| Zeros | 4773 |
| Zeros (%) | 95.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 396 |
| Range | 396 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 12.93792 |
|---|---|
| Coefficient of variation (CV) | 16.850638 |
| Kurtosis | 557.31234 |
| Mean | 0.7678 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.774483 |
| Sum | 3839 |
| Variance | 167.38976 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 0 | 4773 | |
| 1 | 126 | 2.5% |
| 2 | 32 | 0.6% |
| 4 | 11 | 0.2% |
| 5 | 8 | 0.2% |
| 6 | 7 | 0.1% |
| 3 | 6 | 0.1% |
| 18 | 4 | 0.1% |
| 25 | 3 | 0.1% |
| 338 | 2 | < 0.1% |
| Other values (24) | 28 | 0.6% |
| Value | Count | Frequency (%) |
| 0 | 4773 | |
| 1 | 126 | 2.5% |
| 2 | 32 | 0.6% |
| 3 | 6 | 0.1% |
| 4 | 11 | 0.2% |
| 5 | 8 | 0.2% |
| 6 | 7 | 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 396 | 1 | |
| 338 | 2 | |
| 314 | 1 | |
| 294 | 1 | |
| 258 | 1 | |
| 226 | 1 | |
| 208 | 1 | |
| 182 | 1 | |
| 170 | 1 | |
| 122 | 1 |
success
Boolean
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.0 KiB |
| True | |
|---|---|
| False | 130 |
| Value | Count | Frequency (%) |
| True | 4870 | |
| False | 130 | 2.6% |
timeouterrorcount
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 | |
|---|---|
| 1 | 374 |
| 2 | 50 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4576 | |
| 1 | 374 | 7.5% |
| 2 | 50 | 1.0% |
transportunavailableerrorcount
Categorical
IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 283.3 KiB |
| 0 | |
|---|---|
| 2 | 1 |
| 1 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5000 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5000 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4998 | |
| 2 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
tripbuildtimeseconds
Real number (ℝ)
MISSING SKEWED
| Distinct | 2290 |
|---|---|
| Distinct (%) | 47.0% |
| Missing | 130 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.116002 |
| Minimum | 0.47 |
|---|---|
| Maximum | 2052.56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0.47 |
|---|---|
| 5-th percentile | 3.45 |
| Q1 | 7.8525 |
| median | 12.205 |
| Q3 | 17.8575 |
| 95-th percentile | 33.5685 |
| Maximum | 2052.56 |
| Range | 2052.09 |
| Interquartile range (IQR) | 10.005 |
Descriptive statistics
| Standard deviation | 51.406612 |
|---|---|
| Coefficient of variation (CV) | 2.8376356 |
| Kurtosis | 733.79269 |
| Mean | 18.116002 |
| Median Absolute Deviation (MAD) | 4.845 |
| Skewness | 23.380406 |
| Sum | 88224.93 |
| Variance | 2642.6398 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 30.02 | 35 | 0.7% |
| 30.01 | 22 | 0.4% |
| 6.92 | 9 | 0.2% |
| 7.36 | 9 | 0.2% |
| 16.58 | 8 | 0.2% |
| 9 | 8 | 0.2% |
| 11.32 | 8 | 0.2% |
| 13.08 | 8 | 0.2% |
| 11.06 | 8 | 0.2% |
| 30 | 8 | 0.2% |
| Other values (2280) | 4747 | |
| (Missing) | 130 | 2.6% |
| Value | Count | Frequency (%) |
| 0.47 | 1 | |
| 0.87 | 1 | |
| 0.89 | 1 | |
| 0.99 | 1 | |
| 1.01 | 1 | |
| 1.02 | 1 | |
| 1.04 | 1 | |
| 1.09 | 1 | |
| 1.1 | 1 | |
| 1.12 | 1 |
| Value | Count | Frequency (%) |
| 2052.56 | 1 | |
| 1443.41 | 1 | |
| 1178.65 | 1 | |
| 1058.15 | 1 | |
| 824.52 | 1 | |
| 632.14 | 1 | |
| 519.46 | 1 | |
| 475.17 | 1 | |
| 338.64 | 1 | |
| 310.94 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| createtripid | region | createtripid_region | requestdate | aborteddataerrorcount | accommodationunavailableerrorcount | createtripformsubmission_adultcount | badproportionerrorcount | createtripformsubmission_childages | createtripformsubmission_childcount | createtripformsubmission_closestcity_id | createtripformsubmission_closestcity | creationdate | createtripformsubmission_directjourney | createtripformsubmission_durationdays | array_to_string | createtripformsubmission_extrainfo | failtimeseconds | failureindurationserrorcount | createtripformsubmission_fastjourney | firstchoiceaccommodationunavailablecount | noavailabledotwaccommodationerrorcount | nofamilymanualfallbackserrorcount | nogoodscoreerrorcount | norouteserrorcount | jotform_onewaytrip | overnightreductionerrorcount | createtripformsubmission_preferreddate | createtripformsubmission_roomcount | substituteaccommodationunavailablecount | success | timeouterrorcount | transportunavailableerrorcount | tripbuildtimeseconds | createtripformsubmission_twinroompreferred | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 891585467457763 | Southern Italy | 891585467457763_Southern Italy | 2024-01-20 10:44:58.368 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-20 10:45:09.267 | False | 12 | Arts and Culture,History,Adventure | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 1 | NaN | 0 | 2024-05-16 | 1 | 0 | True | 0 | 0 | 9.51 | False |
| 1 | 891585467457763 | Italian Riviera | 891585467457763_Italian Riviera | 2024-01-20 10:44:58.368 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-20 10:45:11.821 | False | 12 | Arts and Culture,History,Adventure | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-05-16 | 1 | 0 | True | 0 | 0 | 12.06 | False |
| 2 | 856446659120383 | Highlands & Islands | 856446659120383_Highlands & Islands | 2024-01-20 10:45:24.467 | 0 | 0 | 2 | 14 | {} | 0 | 833158856 | Coventry | NaT | False | 3 | Relaxation,History | {} | 11.65 | 0 | False | 1 | 1 | 0 | 1 | 9 | NaN | 0 | 2024-05-13 | 1 | 1 | False | 0 | 0 | NaN | False |
| 3 | 856446659120383 | East Highlands | 856446659120383_East Highlands | 2024-01-20 10:45:24.467 | 0 | 0 | 2 | 4 | {} | 0 | 833158856 | Coventry | 2024-01-20 10:45:29.964 | False | 3 | Relaxation,History | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-05-13 | 1 | 0 | True | 0 | 0 | 4.79 | False |
| 4 | 643110738642468 | Yorkshire | 643110738642468_Yorkshire | 2024-01-20 10:46:38.669 | 0 | 0 | 2 | 0 | {} | 0 | 28 | Birmingham | 2024-01-20 10:46:45.532 | False | 4 | History,Nature,Food and Drink | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-08-15 | 1 | 0 | True | 0 | 0 | 5.79 | True |
| 5 | 882120083576575 | Alsace | 882120083576575_Alsace | 2024-01-20 10:48:42.199 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-20 10:48:46.012 | False | 5 | Relaxation,History,Food and Drink,Nature,Arts and Culture | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 2 | NaN | 0 | 2024-05-30 | 1 | 0 | True | 0 | 0 | 2.93 | True |
| 6 | 749696652786878 | Belgium | 749696652786878_Belgium | 2024-01-20 10:50:58.782 | 0 | 0 | 2 | 0 | {} | 0 | 42771065 | Liverpool | 2024-01-20 10:51:10.961 | False | 7 | Food and Drink,History,Nature,Arts and Culture,Nightlife | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-03-16 | 1 | 0 | True | 0 | 0 | 11.48 | False |
| 7 | 639440762388119 | Corsica | 639440762388119_Corsica | 2024-01-20 10:53:39.128 | 0 | 0 | 2 | 0 | {13,11} | 2 | 26 | London | 2024-01-20 10:53:55.616 | False | 14 | Good for kids | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-08-11 | 1 | 0 | True | 0 | 0 | 15.66 | False |
| 8 | 639440762388119 | Hauts-de-France | 639440762388119_Hauts-de-France | 2024-01-20 10:53:39.128 | 0 | 0 | 2 | 0 | {13,11} | 2 | 26 | London | 2024-01-20 10:53:55.467 | False | 14 | Good for kids | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-08-11 | 1 | 0 | True | 0 | 0 | 15.50 | False |
| 9 | 747514586085701 | Southern Italy | 747514586085701_Southern Italy | 2024-01-20 10:58:03.417 | 0 | 0 | 2 | 0 | {} | 0 | 22370660 | Newcastle | 2024-01-20 10:58:09.650 | False | 21 | Relaxation,History,Food and Drink | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 10 | NaN | 0 | 2025-07-01 | 1 | 0 | True | 0 | 0 | 5.22 | False |
| createtripid | region | createtripid_region | requestdate | aborteddataerrorcount | accommodationunavailableerrorcount | createtripformsubmission_adultcount | badproportionerrorcount | createtripformsubmission_childages | createtripformsubmission_childcount | createtripformsubmission_closestcity_id | createtripformsubmission_closestcity | creationdate | createtripformsubmission_directjourney | createtripformsubmission_durationdays | array_to_string | createtripformsubmission_extrainfo | failtimeseconds | failureindurationserrorcount | createtripformsubmission_fastjourney | firstchoiceaccommodationunavailablecount | noavailabledotwaccommodationerrorcount | nofamilymanualfallbackserrorcount | nogoodscoreerrorcount | norouteserrorcount | jotform_onewaytrip | overnightreductionerrorcount | createtripformsubmission_preferreddate | createtripformsubmission_roomcount | substituteaccommodationunavailablecount | success | timeouterrorcount | transportunavailableerrorcount | tripbuildtimeseconds | createtripformsubmission_twinroompreferred | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4990 | 881189589986379 | Southern Italy | 881189589986379_Southern Italy | 2024-01-25 00:23:50.753 | 0 | 0 | 2 | 0 | {} | 0 | 22371672 | Paris | 2024-01-25 00:23:57.342 | False | 10 | Nature,History,Arts and Culture,Food and Drink,Nightlife | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 1 | NaN | 0 | 2024-11-25 | 1 | 0 | True | 0 | 0 | 4.97 | False |
| 4991 | 881189589986379 | Italian Riviera | 881189589986379_Italian Riviera | 2024-01-25 00:23:50.753 | 0 | 0 | 2 | 0 | {} | 0 | 22371672 | Paris | 2024-01-25 00:23:59.994 | False | 10 | Nature,History,Arts and Culture,Food and Drink,Nightlife | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-11-25 | 1 | 0 | True | 0 | 0 | 7.62 | False |
| 4992 | 881189589986379 | Alsace | 881189589986379_Alsace | 2024-01-25 00:23:50.753 | 0 | 0 | 2 | 0 | {} | 0 | 22371672 | Paris | 2024-01-25 00:23:57.911 | False | 10 | Nature,History,Arts and Culture,Food and Drink,Nightlife | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 1 | NaN | 0 | 2024-11-25 | 1 | 0 | True | 0 | 0 | 5.57 | False |
| 4993 | 881189589986379 | North & Central Spain | 881189589986379_North & Central Spain | 2024-01-25 00:23:50.753 | 0 | 0 | 2 | 0 | {} | 0 | 22371672 | Paris | 2024-01-25 00:24:01.362 | False | 10 | Nature,History,Arts and Culture,Food and Drink,Nightlife | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 2 | NaN | 0 | 2024-11-25 | 1 | 0 | True | 0 | 0 | 8.99 | False |
| 4994 | 711213683623923 | Yorkshire | 711213683623923_Yorkshire | 2024-01-25 00:25:44.387 | 0 | 0 | 2 | 0 | {} | 0 | 81683215 | Norwich | 2024-01-25 00:25:54.378 | False | 3 | Relaxation,History,Food and Drink,Nature | {} | NaN | 0 | False | 3 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-03-08 | 1 | 0 | True | 0 | 0 | 9.00 | False |
| 4995 | 643135602249296 | Cornwall | 643135602249296_Cornwall | 2024-01-25 00:26:58.796 | 0 | 0 | 2 | 0 | {} | 0 | 81683215 | Norwich | 2024-01-25 00:27:09.090 | False | 3 | Relaxation,History,Food and Drink,Nature | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-03-15 | 1 | 0 | True | 0 | 0 | 9.44 | False |
| 4996 | 614287184247196 | French Riviera | 614287184247196_French Riviera | 2024-01-25 00:37:24.226 | 0 | 0 | 1 | 1 | {} | 0 | 26 | London | 2024-01-25 00:37:28.452 | False | 3 | Nightlife,Nature,Adventure | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-03-21 | 1 | 0 | True | 0 | 0 | 3.57 | False |
| 4997 | 620037653551287 | Alsace | 620037653551287_Alsace | 2024-01-25 00:37:55.999 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-25 00:38:04.739 | False | 7 | Nightlife | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-02-03 | 1 | 0 | True | 0 | 0 | 7.48 | False |
| 4998 | 899773309676452 | Switzerland | 899773309676452_Switzerland | 2024-01-25 00:41:38.228 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-25 00:41:51.163 | False | 7 | History,Relaxation,Nature,Adventure | {} | NaN | 0 | False | 1 | 0 | 0 | 0 | 0 | NaN | 0 | 2024-03-20 | 1 | 0 | True | 0 | 0 | 11.73 | False |
| 4999 | 829303111514315 | Highlands & Islands | 829303111514315_Highlands & Islands | 2024-01-25 00:44:32.072 | 0 | 0 | 2 | 0 | {} | 0 | 26 | London | 2024-01-25 00:44:35.807 | False | 7 | Nature,History,Adventure,Arts and Culture | {} | NaN | 0 | False | 0 | 0 | 0 | 0 | 1 | NaN | 0 | 2025-05-19 | 1 | 0 | True | 0 | 0 | 2.24 | False |